﻿GO
/****** Object:  Table [dbo].[Countries]    Script Date: 09/27/2010 21:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Countries](
	[CountryID] [int] IDENTITY(1,1) NOT NULL,
	[CountryCode] [char](2) NOT NULL,
	[CountryName] [nvarchar](255) NOT NULL,
 CONSTRAINT [PK_Countries_1] PRIMARY KEY CLUSTERED 
(
	[CountryID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Log]    Script Date: 09/27/2010 21:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Log](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Date] [datetime] NOT NULL,
	[Thread] [varchar](255) NOT NULL,
	[Level] [varchar](50) NOT NULL,
	[Logger] [varchar](255) NOT NULL,
	[Message] [varchar](4000) NOT NULL,
	[Exception] [varchar](2000) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Genders]    Script Date: 09/27/2010 21:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Genders](
	[GenderID] [int] IDENTITY(1,1) NOT NULL,
	[GenderName] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_Genders] PRIMARY KEY CLUSTERED 
(
	[GenderID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Specialities]    Script Date: 09/27/2010 21:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Specialities](
	[SpecialityID] [int] IDENTITY(1,1) NOT NULL,
	[SpecialityName] [nvarchar](256) NULL,
 CONSTRAINT [PK_Specialities] PRIMARY KEY CLUSTERED 
(
	[SpecialityID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Programs]    Script Date: 09/27/2010 21:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Programs](
	[ProgramID] [int] IDENTITY(1,1) NOT NULL,
	[ProgramName] [nvarchar](255) NOT NULL,
	[ProgramIsDefault] [bit] NOT NULL,
 CONSTRAINT [PK_Programs] PRIMARY KEY CLUSTERED 
(
	[ProgramID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ProfessionalBackgrounds]    Script Date: 09/27/2010 21:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProfessionalBackgrounds](
	[ProfessionalBackgroundID] [int] IDENTITY(1,1) NOT NULL,
	[ProfessionalBackgroundName] [nvarchar](256) NULL,
 CONSTRAINT [PK_ProfessionalBackgrounds] PRIMARY KEY CLUSTERED 
(
	[ProfessionalBackgroundID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TargetAreas]    Script Date: 09/27/2010 21:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TargetAreas](
	[TargetAreaID] [int] IDENTITY(1,1) NOT NULL,
	[TargetAreaProgramID] [int] NOT NULL,
	[TargetAreaCountryID] [int] NOT NULL,
	[TargetAreaOrdinal] [int] NOT NULL,
	[TargetAreaVisualCode] [nvarchar](10) NULL,
	[TargetAreaCenter] [nvarchar](255) NULL,
 CONSTRAINT [PK_TargetAreas] PRIMARY KEY CLUSTERED 
(
	[TargetAreaID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Surveys]    Script Date: 09/27/2010 21:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Surveys](
	[SurveyID] [int] IDENTITY(1,1) NOT NULL,
	[SurveyProgramID] [int] NOT NULL,
	[SurveyPeriod] [nvarchar](50) NOT NULL,
	[SurveyOrdinal] [int] NOT NULL,
	[SurveyYear] [int] NOT NULL,
 CONSTRAINT [PK_Surveys] PRIMARY KEY CLUSTERED 
(
	[SurveyID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Seminars]    Script Date: 09/27/2010 21:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Seminars](
	[SeminarID] [int] IDENTITY(1,1) NOT NULL,
	[SeminarTargetAreaID] [int] NOT NULL,
	[SeminarOrdinal] [int] NOT NULL,
	[SeminarCity] [nvarchar](256) NULL,
	[SeminarDate] [date] NULL,
 CONSTRAINT [PK_Seminars] PRIMARY KEY CLUSTERED 
(
	[SeminarID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Reporters]    Script Date: 09/27/2010 21:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Reporters](
	[ReporterID] [int] IDENTITY(1,1) NOT NULL,
	[ReporterTargetAreaID] [int] NOT NULL,
	[ReporterUserID] [uniqueidentifier] NOT NULL,
	[ReporterEmail] [nvarchar](256) NULL,
	[ReporterName] [nvarchar](256) NULL,
	[ReporterSurname] [nvarchar](256) NULL,
	[ReporterGenderID] [int] NOT NULL,
	[ReporterAge] [int] NULL,
	[ReporterYearsOfExperience] [int] NULL,
	[ReporterAcademyDegree] [nvarchar] (256) NULL,
	[ReporterDepartment] [nvarchar](256) NULL,
	[ReporterPosition] [nvarchar](256) NULL,
	[ReporterRole] [nvarchar](256) NULL,
	[ReporterDevotedTime] [int] NULL,
 CONSTRAINT [PK_Reporters] PRIMARY KEY CLUSTERED 
(
	[ReporterID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SurveyResults]    Script Date: 09/27/2010 21:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SurveyResults](
	[SurveyResultsID] [int] IDENTITY(1,1) NOT NULL,
	[SurveyResultsFilled] [bit] NOT NULL,
	[SurveyResultsSurveyID] [int] NOT NULL,
	[SurveyResultsTargetAreaID] [int] NOT NULL,
	[SurveyResultsPopulation] [int] NULL,
	[SurveyResultsHospitals] [int] NULL,
	[SurveyResultsBeds] [int] NULL,
	[SurveyResultsDeath] [int] NULL,
	[SurveyResultsBedsICU] [int] NULL,
	[SurveyResultsNeurosurgery] [int] NULL,
	[SurveyResultsAdmittedICU] [int] NULL,
	[SurveyResultsDeathICU] [int] NULL,
	[SurveyResultsPotentialDonors] [int] NULL,
	[SurveyResultsEligibleDonors] [int] NULL,
	[SurveyResultsActualDonors] [int] NULL,
	[SurveyResultsUtilizedDonors] [int] NULL,
	[SurveyResultsProcuredOrgans] [int] NULL,
	[SurveyResultsCadaveric] [int] NULL,
	[SurveyResultsDonorCoordinatorsFull] [int] NULL,
	[SurveyResultsDonorCoordinatorsPart] [int] NULL,
 CONSTRAINT [PK_SurveyResults] PRIMARY KEY CLUSTERED 
(
	[SurveyResultsID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TestResults]    Script Date: 09/27/2010 21:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TestResults](
	[TestResultID] [int] IDENTITY(1,1) NOT NULL,
	[TestResultSeminarID] [int] NOT NULL,
	[TestResultCorrectAnswers] [int] NOT NULL,
	[TestResultIncorrectAnswers] [int] NOT NULL,
	[TestResultNotAnswered] [int] NOT NULL,
 CONSTRAINT [PK_TestResults] PRIMARY KEY CLUSTERED 
(
	[TestResultID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Participants]    Script Date: 09/27/2010 21:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Participants](
	[ParticipantID] [int] IDENTITY(1,1) NOT NULL,
	[ParticipantSeminarID] [int] NOT NULL,
	[ParticipantName] [nvarchar](256) NULL,
	[ParticipantSurname] [nvarchar](256) NULL,
	[ParticipantGenderID] [int] NOT NULL,
	[ParticipantAge] [int] NULL,
	[ParticipantEmail] [nvarchar](256) NULL,
	[ParticipantOrganization] [nvarchar](256) NULL,
	[ParticipantDepartment] [nvarchar](256) NULL,
	[ParticipantPosition] [nvarchar](256) NULL,
	[ParticipantSpeciality] [nvarchar](256) NULL,
	[ParticipantAddress] [nvarchar](256) NULL,
	[ParticipantPostalCode] [nvarchar](10) NULL,
	[ParticipantCity] [nvarchar](256) NULL,
	[ParticipantPhone] [nvarchar](15) NULL,
	[ParticipantFax] [nvarchar](15) NULL,
	[ParticipantProfessionalBackgroundID] [int] NOT NULL,
	[ParticipantSpecialityID] [int] NOT NULL,
 CONSTRAINT [PK_Participants] PRIMARY KEY CLUSTERED 
(
	[ParticipantID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[FollowUps]    Script Date: 09/27/2010 21:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FollowUps](
	[FollowUpSeminarID] [int] NOT NULL,
	[FollowUpID] [int] IDENTITY(1,1) NOT NULL,
	[FollowUpTakePart] [int] NULL,
	[FollowUpAttitude] [int] NULL,
	[FollowUpGenderID] [int] NULL,
	[FollowUpConfident1] [int] NULL,
	[FollowUpConfident2] [int] NULL,
	[FollowUpConfident3] [int] NULL,
	[FollowUpConfident4] [int] NULL,
	[FollowUpConfident5] [int] NULL,
	[FollowUpConfident6] [int] NULL,
	[FollowUpConfident7] [int] NULL,
	[FollowUpConfident8] [int] NULL,
	[FollowUpConfident9] [int] NULL,
	[FollowUpConfident10] [int] NULL,
	[FollowUpProfessionalBackgroundID] [int] NOT NULL,
	[FollowUpSpecialityID] [int] NOT NULL,
	[FollowUpAge] [int] NULL,
 CONSTRAINT [PK_FollowUps] PRIMARY KEY CLUSTERED 
(
	[FollowUpID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Assessments]    Script Date: 09/27/2010 21:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Assessments](
	[AssessmentID] [int] IDENTITY(1,1) NOT NULL,
	[AssessmentSeminarID] [int] NULL,
	[AssessmentOrganDonorC] [int] NULL,
	[AssessmentOrganDonorP] [int] NULL,
	[AssessmentOrganDonorQ] [int] NULL,
	[AssessmentCaseStudiesC] [int] NULL,
	[AssessmentCaseStudiesP] [int] NULL,
	[AssessmentCaseStudiesQ] [int] NULL,
	[AssessmentBrainDeathC] [int] NULL,
	[AssessmentBrainDeathP] [int] NULL,
	[AssessmentBrainDeathQ] [int] NULL,
	[AssessmentSimulationC] [int] NULL,
	[AssessmentSimulationP] [int] NULL,
	[AssessmentSimulationQ] [int] NULL,
	[AssessmentDonorC] [int] NULL,
	[AssessmentDonorP] [int] NULL,
	[AssessmentDonorQ] [int] NULL,
	[AssessmentApproachC] [int] NULL,
	[AssessmentApproachP] [int] NULL,
	[AssessmentApproachQ] [int] NULL,
	[AssessmentInterviewsC] [int] NULL,
	[AssessmentInterviewsP] [int] NULL,
	[AssessmentInterviewsQ] [int] NULL,
	[AssessmentRetrievalC] [int] NULL,
	[AssessmentRetrievalP] [int] NULL,
	[AssessmentRetrievalQ] [int] NULL,
	[AssessmentOrganization] [int] NULL,
	[AssessmentTeaching] [int] NULL,
	[AssessmentSupport] [int] NULL,
	[AssessmentSecretariat] [int] NULL,
	[AssessmentPreRegistration] [int] NULL,
	[AssessmentPostRegistration] [int] NULL,
	[AssessmentApplicability] [int] NULL,
	[AssessmentOverall] [int] NULL,
 CONSTRAINT [PK_Assessments] PRIMARY KEY CLUSTERED 
(
	[AssessmentID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Default [DF_SurveyResults_SurveyResultsFilled]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[SurveyResults] ADD  CONSTRAINT [DF_SurveyResults_SurveyResultsFilled]  DEFAULT ((0)) FOR [SurveyResultsFilled]
GO
/****** Object:  ForeignKey [FK_Assessments_Seminars]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[Assessments]  WITH CHECK ADD  CONSTRAINT [FK_Assessments_Seminars] FOREIGN KEY([AssessmentSeminarID])
REFERENCES [dbo].[Seminars] ([SeminarID])
GO
ALTER TABLE [dbo].[Assessments] CHECK CONSTRAINT [FK_Assessments_Seminars]
GO
/****** Object:  ForeignKey [FK_FollowUps_Genders]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[FollowUps]  WITH CHECK ADD  CONSTRAINT [FK_FollowUps_Genders] FOREIGN KEY([FollowUpGenderID])
REFERENCES [dbo].[Genders] ([GenderID])
GO
ALTER TABLE [dbo].[FollowUps] CHECK CONSTRAINT [FK_FollowUps_Genders]
GO
/****** Object:  ForeignKey [FK_FollowUps_ProfessionalBackgrounds]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[FollowUps]  WITH CHECK ADD  CONSTRAINT [FK_FollowUps_ProfessionalBackgrounds] FOREIGN KEY([FollowUpProfessionalBackgroundID])
REFERENCES [dbo].[ProfessionalBackgrounds] ([ProfessionalBackgroundID])
GO
ALTER TABLE [dbo].[FollowUps] CHECK CONSTRAINT [FK_FollowUps_ProfessionalBackgrounds]
GO
/****** Object:  ForeignKey [FK_FollowUps_Seminars]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[FollowUps]  WITH CHECK ADD  CONSTRAINT [FK_FollowUps_Seminars] FOREIGN KEY([FollowUpSeminarID])
REFERENCES [dbo].[Seminars] ([SeminarID])
GO
ALTER TABLE [dbo].[FollowUps] CHECK CONSTRAINT [FK_FollowUps_Seminars]
GO
/****** Object:  ForeignKey [FK_FollowUps_Specialities]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[FollowUps]  WITH CHECK ADD  CONSTRAINT [FK_FollowUps_Specialities] FOREIGN KEY([FollowUpSpecialityID])
REFERENCES [dbo].[Specialities] ([SpecialityID])
GO
ALTER TABLE [dbo].[FollowUps] CHECK CONSTRAINT [FK_FollowUps_Specialities]
GO
/****** Object:  ForeignKey [FK_Participants_Genders]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[Participants]  WITH CHECK ADD  CONSTRAINT [FK_Participants_Genders] FOREIGN KEY([ParticipantGenderID])
REFERENCES [dbo].[Genders] ([GenderID])
GO
ALTER TABLE [dbo].[Participants] CHECK CONSTRAINT [FK_Participants_Genders]
GO
/****** Object:  ForeignKey [FK_Participants_ProfessionalBackgrounds]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[Participants]  WITH CHECK ADD  CONSTRAINT [FK_Participants_ProfessionalBackgrounds] FOREIGN KEY([ParticipantProfessionalBackgroundID])
REFERENCES [dbo].[ProfessionalBackgrounds] ([ProfessionalBackgroundID])
GO
ALTER TABLE [dbo].[Participants] CHECK CONSTRAINT [FK_Participants_ProfessionalBackgrounds]
GO
/****** Object:  ForeignKey [FK_Participants_Seminars]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[Participants]  WITH CHECK ADD  CONSTRAINT [FK_Participants_Seminars] FOREIGN KEY([ParticipantSeminarID])
REFERENCES [dbo].[Seminars] ([SeminarID])
GO
ALTER TABLE [dbo].[Participants] CHECK CONSTRAINT [FK_Participants_Seminars]
GO
/****** Object:  ForeignKey [FK_Participants_Specialities]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[Participants]  WITH CHECK ADD  CONSTRAINT [FK_Participants_Specialities] FOREIGN KEY([ParticipantSpecialityID])
REFERENCES [dbo].[Specialities] ([SpecialityID])
GO
ALTER TABLE [dbo].[Participants] CHECK CONSTRAINT [FK_Participants_Specialities]
GO
/****** Object:  ForeignKey [FK_Reporters_Genders]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[Reporters]  WITH CHECK ADD  CONSTRAINT [FK_Reporters_Genders] FOREIGN KEY([ReporterGenderID])
REFERENCES [dbo].[Genders] ([GenderID])
GO
ALTER TABLE [dbo].[Reporters] CHECK CONSTRAINT [FK_Reporters_Genders]
GO
/****** Object:  ForeignKey [FK_Reporters_TargetAreas]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[Reporters]  WITH CHECK ADD  CONSTRAINT [FK_Reporters_TargetAreas] FOREIGN KEY([ReporterTargetAreaID])
REFERENCES [dbo].[TargetAreas] ([TargetAreaID])
GO
ALTER TABLE [dbo].[Reporters] CHECK CONSTRAINT [FK_Reporters_TargetAreas]
GO
/****** Object:  ForeignKey [FK_Seminars_TargetAreas]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[Seminars]  WITH CHECK ADD  CONSTRAINT [FK_Seminars_TargetAreas] FOREIGN KEY([SeminarTargetAreaID])
REFERENCES [dbo].[TargetAreas] ([TargetAreaID])
GO
ALTER TABLE [dbo].[Seminars] CHECK CONSTRAINT [FK_Seminars_TargetAreas]
GO
/****** Object:  ForeignKey [FK_SurveyResults_SurveyResults]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[SurveyResults]  WITH CHECK ADD  CONSTRAINT [FK_SurveyResults_SurveyResults] FOREIGN KEY([SurveyResultsTargetAreaID])
REFERENCES [dbo].[TargetAreas] ([TargetAreaID])
GO
ALTER TABLE [dbo].[SurveyResults] CHECK CONSTRAINT [FK_SurveyResults_SurveyResults]
GO
/****** Object:  ForeignKey [FK_SurveyResults_Surveys]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[SurveyResults]  WITH CHECK ADD  CONSTRAINT [FK_SurveyResults_Surveys] FOREIGN KEY([SurveyResultsSurveyID])
REFERENCES [dbo].[Surveys] ([SurveyID])
GO
ALTER TABLE [dbo].[SurveyResults] CHECK CONSTRAINT [FK_SurveyResults_Surveys]
GO
/****** Object:  ForeignKey [FK_Surveys_Programs]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[Surveys]  WITH CHECK ADD  CONSTRAINT [FK_Surveys_Programs] FOREIGN KEY([SurveyProgramID])
REFERENCES [dbo].[Programs] ([ProgramID])
GO
ALTER TABLE [dbo].[Surveys] CHECK CONSTRAINT [FK_Surveys_Programs]
GO
/****** Object:  ForeignKey [FK_TargetAreas_Countries]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[TargetAreas]  WITH CHECK ADD  CONSTRAINT [FK_TargetAreas_Countries] FOREIGN KEY([TargetAreaCountryID])
REFERENCES [dbo].[Countries] ([CountryID])
GO
ALTER TABLE [dbo].[TargetAreas] CHECK CONSTRAINT [FK_TargetAreas_Countries]
GO
/****** Object:  ForeignKey [FK_TargetAreas_Program]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[TargetAreas]  WITH CHECK ADD  CONSTRAINT [FK_TargetAreas_Program] FOREIGN KEY([TargetAreaProgramID])
REFERENCES [dbo].[Programs] ([ProgramID])
GO
ALTER TABLE [dbo].[TargetAreas] CHECK CONSTRAINT [FK_TargetAreas_Program]
GO
/****** Object:  ForeignKey [FK_TestResults_Seminars]    Script Date: 09/27/2010 21:51:32 ******/
ALTER TABLE [dbo].[TestResults]  WITH CHECK ADD  CONSTRAINT [FK_TestResults_Seminars] FOREIGN KEY([TestResultSeminarID])
REFERENCES [dbo].[Seminars] ([SeminarID])
GO
ALTER TABLE [dbo].[TestResults] CHECK CONSTRAINT [FK_TestResults_Seminars]
GO
